package org.jeecg.modules.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import io.lettuce.core.dynamic.annotation.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.system.entity.ZkWorkBook;
import org.jeecg.modules.system.entity.ZkWorkBookData;

import java.util.List;

/**
 * @Description: 作业指导书
 * @Author: jeecg-boot
 * @Date:   2024-07-01
 * @Version: V1.0
 */
public interface ZkWorkBookMapper extends BaseMapper<ZkWorkBook> {

    /**
     * 查询全部作业指导书
     */
    List<ZkWorkBookData> queryZkWorkBook(String level,String customName,String proces,String productNumber,String productName);

    //分页查询
    List<ZkWorkBookData>queryZkWorkBookData(@Param("page") Page<ZkWorkBookData> page, @Param("zkWorkBookData") ZkWorkBookData zkWorkBookData);

    //查询客户名称
    @Select("select DISTINCT  custom_name from zk_work_book")
    List<String> customName();

    //查询工序
    @Select("select DISTINCT  proces from zk_work_book")
    List<String> quryProces();

    //查询产品编号
    @Select("select DISTINCT  product_number from zk_work_book")
    List<String> queryProductNumber();

    //查询产品名称
    @Select("select DISTINCT  product_name from zk_work_book")
    List<String> queryProductName();
}
